﻿CREATE TABLE [dbo].[User] (
    [EmpID]     INT           NOT NULL,
    [FirstName] NVARCHAR(50)     NOT NULL,
    [LastName]  NVARCHAR(50)     NOT NULL,
    [UserName]  NVARCHAR (50) NOT NULL,
    [Password]  NVARCHAR (50) NOT NULL,
    [PhotoID]   BINARY (50)   NULL,
    [UserDiabled] BIT NULL, 
    CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ([EmpID] ASC)
);

